DWM.xls - New version

Author: Walter | Created: 2010-04-28 14:46 | Last Activity: 2010-06-2 15:05

Original Post

2010-04-28 14:46
Hi,
I posted a new version of DWM.xls

There are many changes:

- Configuration worksheet: Check the different options (time/date formats, colors, amount of days)

- New column "Entered" (different from "Created", as it's updated on every reentry). It comes to fix a bug reported by Mark (Tasks will be sorted by this column instead of “Created”)

- Import tasks from old file: No need to copy/paste from your old file anymore. It will only work with files formatted for the old version (without additions, etc).

- Closing Date removed (it duplicated "End Time")


There's quite a bit of programming. I hope there aren't too many bugs.
Let me know what you think.

DWM.xls
http://rapidshare.com/files/381174218/DWM.xls

DWM for Excel.pdf
http://rapidshare.com/files/381174277/DWM_for_Excel.pdf

Walter

Reply by moises

2010-04-28 18:51
No warranty?

Just kidding.

I look forward to trying this. You've done a yeoman's job creating this. Thanks.

Reply by moises

2010-04-29 2:02
Works nicely on my Windows machine. But it won't work correctly on my Vista machine.

On the latter, immediately after I download it, if I hit "Apply Changes" on the Configuration Tab, I get "A Problem Occurred When Trying to Set Colors." And it's prone to crashing.

Reply by Walter

2010-04-29 6:55
Hi moises,

I forgot to warn about that. I don't know about Vista, but I had the same problem with Excel 2007. Apparently there's some incompatibility (since I'm using Excel's old method to set colors) and I couldn't find a workaround yet.

By now, this has to be done manually through Excel preferences. I can tell you how this is done if you want.

Reply by moises

2010-04-29 12:21
Hi Walter,

That's great. Please let me know how to modify Excel 2007 on my Vista machine. The configurability of the dates is something that will be most useful on my Vista (home) machine. Thanks.

Reply by Walter

2010-05-2 8:22
Hi moses,

Excluding the colors, the other configuration options should work without problems. They don't?

Reply by moises

2010-05-2 16:54
I never was able to start work in Excel 2007. It's not that I changed the configuration for the colors. I would get the error without changing anything.

Reply by Walter

2010-05-3 0:08
Meaning that you open the file, and immediately you're shown with an error message?
And if so, Excel crashes afterwards?

Reply by moises

2010-05-3 0:15
It would return an error message as soon as I hit "Apply Changes" even if I made no changes and had entered no data in any tab.

Reply by Walter

2010-05-3 8:54
If "A Problem Occurred When Trying to Set Colors" is shown, the rest of the configuration options (date formats, entry days) are still applied, only the colors are skipped.

Can you check if that's your case? (Assuming that you can continue working after the message its shown. I didn't understand if there's a crash or not).
You should enter a task and see if the date formats are the ones you specified, and so on.

Reply by moises

2010-05-3 14:40
OK. I will try it again when I get home tonight.

Reply by Ilse

2010-05-3 19:40
For me the file works perfect in Excel 2007. Thank you Walter. I has been great experience using your DWM file.

Reply by moises

2010-05-4 0:57
Walter,

I downloaded it a few more times and crashed it a few more times.

I take a brand-new file. I add a few tasks to make sure it's working. Then I change the date formats and the month setting 28 days, and the week to 10 days. I ignore the error message about the colors. I add a few more tasks and it crashes.

Your older version is working fine for me in Excel 2007, so I will stick with that.

Thanks.

Reply by Walter

2010-05-4 7:26
Moises,
I'll tell you what... i'll try to detect if the current version is 2007, and if so, skip the color setting.
Maybe this is what's causing the crashing.

Ilse,
I'm glad you find it useful :-)

Reply by Walter

2010-05-4 17:24
Moises,
I've been playing with the options and I've found out that if you save the file as the 2007 format .xlsm, it does work, even with the colors.

With the current version, there's some hard-coding that makes the program to expect exactly "DWM.xls" (as I think you know). I'm preparing a version that can deal with any file name.

But it would be good if you could try with the newer format, and see how it works.

Thanks,
Walter

Reply by moises

2010-05-5 0:29
Walter,

That seems to have done the trick. Thanks!

Before this, I was always prompted to save as an Excel 97-2003 Workbook. Now I saved it as an Excel Macro-enabled Workbook.

It looks like you solved another problem for me. I look forward to using it.

Your dedication to this is much appreciated.

moises

Reply by KP

2010-05-26 9:58
Hi Walter,

Your macros are great, they stopped me giving up on DWM. However I have one question, on my pc (XP with Excel 2007) it takes about 20 seconds for the macros to run. I'm using an .xlsm file format. Any suggestions on why it runs so slowly?

Thanks in advance!!
Kirstie

(It's not all bad though as it does give me an opportunity to practice my deep breathing)

Reply by Walter

2010-05-26 11:40
Hi, Kirstie

Everytime you execute a macro you have to wait 20 seconds, or just when you open the file?

I really don't know why would that be, I'm sure it's not something related to the program itself.

I don't know of any, but maybe there are antivirus programs that check office macros before they get executed?

Anybody else having the same issue?

Reply by moises

2010-05-26 18:15
No problems with XP Professional with Excel 2003.
No problems with Vista and Excel 2007.

Reply by KP

2010-05-28 7:25
Hi Walter

The waiting is everytime I execute a macro, though I've been timing all my actions since I posted and 20 seconds was the most extreme, between 6 and 10 is the average (which isn't really a problem, I've just got used to life happening 'instantly').

Thanks for responding so promptly!!

Kirstie

Reply by Walter

2010-06-2 15:05
You are welcome, I'm sorry I couldn't help.

I'm going to post a new version soon, with a copy option (useful for recurrent tasks).